package cn.hl.hm.dao;

import cn.hl.hm.entity.CountrySubdivisionCode;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CountrySubdivisionCodeMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(CountrySubdivisionCode record);

    int insertSelective(CountrySubdivisionCode record);

    
    
    CountrySubdivisionCode selectByPrimaryKey(Integer id);
    @Select("select csc from CountrySubdivisionCode where csc_name=#{cscname} ")
    CountrySubdivisionCode selectCountrySubdivisionCode(@Param("cscname")String cscname);

    List<CountrySubdivisionCode> selectAll();

    int updateByPrimaryKeySelective(CountrySubdivisionCode record);

    int updateByPrimaryKey(CountrySubdivisionCode record);

    List<CountrySubdivisionCode> selectFirstLevel();

    List<CountrySubdivisionCode> selectByProvincialCode(@Param("provincialCode") String provincialCode);
}